package com.yjd.bi.etl.sql;

/**
 * Created by yjd-wap on 2017/4/13.
 */
public class FundsMonthSqlConstants {

    public static final String run_max_info = "select a.run_month,a.run_date,a.start_userid,a.date_status  from yjd_funds_run_record a where a.id = (select max(t.id) from yjd_funds_run_record t)";

    public static final String get_max_user_id = "select a.user_id from yjd_user a,yjd_funds b where a.user_id = b.user_id and (b.recharge>0 or b.borrow>0) and a.regdate <=? order by a.user_id desc limit 1";


    public static final String yjd_pf_balance_insert = "insert into yjd_pf_balance(invest_balance,borrow_balance,bankdepo_invest_balance,bankdepo_borrow_balance,run_date,create_time) values (?,?,?,?,?,?)";

}

